package com.bootdo.system.domain;

import java.util.ArrayList;
import java.util.List;

public class TbSviporderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TbSviporderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andTitleIsNull() {
            addCriterion("title is null");
            return (Criteria) this;
        }

        public Criteria andTitleIsNotNull() {
            addCriterion("title is not null");
            return (Criteria) this;
        }

        public Criteria andTitleEqualTo(String value) {
            addCriterion("title =", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotEqualTo(String value) {
            addCriterion("title <>", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThan(String value) {
            addCriterion("title >", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThanOrEqualTo(String value) {
            addCriterion("title >=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThan(String value) {
            addCriterion("title <", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThanOrEqualTo(String value) {
            addCriterion("title <=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLike(String value) {
            addCriterion("title like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotLike(String value) {
            addCriterion("title not like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleIn(List<String> values) {
            addCriterion("title in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotIn(List<String> values) {
            addCriterion("title not in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleBetween(String value1, String value2) {
            addCriterion("title between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotBetween(String value1, String value2) {
            addCriterion("title not between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andProductidIsNull() {
            addCriterion("productId is null");
            return (Criteria) this;
        }

        public Criteria andProductidIsNotNull() {
            addCriterion("productId is not null");
            return (Criteria) this;
        }

        public Criteria andProductidEqualTo(Integer value) {
            addCriterion("productId =", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotEqualTo(Integer value) {
            addCriterion("productId <>", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidGreaterThan(Integer value) {
            addCriterion("productId >", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidGreaterThanOrEqualTo(Integer value) {
            addCriterion("productId >=", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLessThan(Integer value) {
            addCriterion("productId <", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLessThanOrEqualTo(Integer value) {
            addCriterion("productId <=", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidIn(List<Integer> values) {
            addCriterion("productId in", values, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotIn(List<Integer> values) {
            addCriterion("productId not in", values, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidBetween(Integer value1, Integer value2) {
            addCriterion("productId between", value1, value2, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotBetween(Integer value1, Integer value2) {
            addCriterion("productId not between", value1, value2, "productid");
            return (Criteria) this;
        }

        public Criteria andProductclassIsNull() {
            addCriterion("productClass is null");
            return (Criteria) this;
        }

        public Criteria andProductclassIsNotNull() {
            addCriterion("productClass is not null");
            return (Criteria) this;
        }

        public Criteria andProductclassEqualTo(String value) {
            addCriterion("productClass =", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassNotEqualTo(String value) {
            addCriterion("productClass <>", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassGreaterThan(String value) {
            addCriterion("productClass >", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassGreaterThanOrEqualTo(String value) {
            addCriterion("productClass >=", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassLessThan(String value) {
            addCriterion("productClass <", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassLessThanOrEqualTo(String value) {
            addCriterion("productClass <=", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassLike(String value) {
            addCriterion("productClass like", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassNotLike(String value) {
            addCriterion("productClass not like", value, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassIn(List<String> values) {
            addCriterion("productClass in", values, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassNotIn(List<String> values) {
            addCriterion("productClass not in", values, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassBetween(String value1, String value2) {
            addCriterion("productClass between", value1, value2, "productclass");
            return (Criteria) this;
        }

        public Criteria andProductclassNotBetween(String value1, String value2) {
            addCriterion("productClass not between", value1, value2, "productclass");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNull() {
            addCriterion("orderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("orderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(Integer value) {
            addCriterion("orderId =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(Integer value) {
            addCriterion("orderId <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(Integer value) {
            addCriterion("orderId >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderId >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(Integer value) {
            addCriterion("orderId <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(Integer value) {
            addCriterion("orderId <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<Integer> values) {
            addCriterion("orderId in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<Integer> values) {
            addCriterion("orderId not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(Integer value1, Integer value2) {
            addCriterion("orderId between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(Integer value1, Integer value2) {
            addCriterion("orderId not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNull() {
            addCriterion("productName is null");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNotNull() {
            addCriterion("productName is not null");
            return (Criteria) this;
        }

        public Criteria andProductnameEqualTo(String value) {
            addCriterion("productName =", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotEqualTo(String value) {
            addCriterion("productName <>", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThan(String value) {
            addCriterion("productName >", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThanOrEqualTo(String value) {
            addCriterion("productName >=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThan(String value) {
            addCriterion("productName <", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThanOrEqualTo(String value) {
            addCriterion("productName <=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLike(String value) {
            addCriterion("productName like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotLike(String value) {
            addCriterion("productName not like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameIn(List<String> values) {
            addCriterion("productName in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotIn(List<String> values) {
            addCriterion("productName not in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameBetween(String value1, String value2) {
            addCriterion("productName between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotBetween(String value1, String value2) {
            addCriterion("productName not between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andProducttypeIsNull() {
            addCriterion("productType is null");
            return (Criteria) this;
        }

        public Criteria andProducttypeIsNotNull() {
            addCriterion("productType is not null");
            return (Criteria) this;
        }

        public Criteria andProducttypeEqualTo(String value) {
            addCriterion("productType =", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeNotEqualTo(String value) {
            addCriterion("productType <>", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeGreaterThan(String value) {
            addCriterion("productType >", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeGreaterThanOrEqualTo(String value) {
            addCriterion("productType >=", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeLessThan(String value) {
            addCriterion("productType <", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeLessThanOrEqualTo(String value) {
            addCriterion("productType <=", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeLike(String value) {
            addCriterion("productType like", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeNotLike(String value) {
            addCriterion("productType not like", value, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeIn(List<String> values) {
            addCriterion("productType in", values, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeNotIn(List<String> values) {
            addCriterion("productType not in", values, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeBetween(String value1, String value2) {
            addCriterion("productType between", value1, value2, "producttype");
            return (Criteria) this;
        }

        public Criteria andProducttypeNotBetween(String value1, String value2) {
            addCriterion("productType not between", value1, value2, "producttype");
            return (Criteria) this;
        }

        public Criteria andProductpriceIsNull() {
            addCriterion("productPrice is null");
            return (Criteria) this;
        }

        public Criteria andProductpriceIsNotNull() {
            addCriterion("productPrice is not null");
            return (Criteria) this;
        }

        public Criteria andProductpriceEqualTo(Integer value) {
            addCriterion("productPrice =", value, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceNotEqualTo(Integer value) {
            addCriterion("productPrice <>", value, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceGreaterThan(Integer value) {
            addCriterion("productPrice >", value, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("productPrice >=", value, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceLessThan(Integer value) {
            addCriterion("productPrice <", value, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceLessThanOrEqualTo(Integer value) {
            addCriterion("productPrice <=", value, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceIn(List<Integer> values) {
            addCriterion("productPrice in", values, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceNotIn(List<Integer> values) {
            addCriterion("productPrice not in", values, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceBetween(Integer value1, Integer value2) {
            addCriterion("productPrice between", value1, value2, "productprice");
            return (Criteria) this;
        }

        public Criteria andProductpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("productPrice not between", value1, value2, "productprice");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(Integer value) {
            addCriterion("quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(Integer value) {
            addCriterion("quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(Integer value) {
            addCriterion("quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(Integer value) {
            addCriterion("quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<Integer> values) {
            addCriterion("quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<Integer> values) {
            addCriterion("quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(Integer value1, Integer value2) {
            addCriterion("quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andTotalpriceIsNull() {
            addCriterion("totalPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalpriceIsNotNull() {
            addCriterion("totalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalpriceEqualTo(Integer value) {
            addCriterion("totalPrice =", value, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceNotEqualTo(Integer value) {
            addCriterion("totalPrice <>", value, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceGreaterThan(Integer value) {
            addCriterion("totalPrice >", value, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("totalPrice >=", value, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceLessThan(Integer value) {
            addCriterion("totalPrice <", value, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceLessThanOrEqualTo(Integer value) {
            addCriterion("totalPrice <=", value, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceIn(List<Integer> values) {
            addCriterion("totalPrice in", values, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceNotIn(List<Integer> values) {
            addCriterion("totalPrice not in", values, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceBetween(Integer value1, Integer value2) {
            addCriterion("totalPrice between", value1, value2, "totalprice");
            return (Criteria) this;
        }

        public Criteria andTotalpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("totalPrice not between", value1, value2, "totalprice");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountIsNull() {
            addCriterion("refunded_amount is null");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountIsNotNull() {
            addCriterion("refunded_amount is not null");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountEqualTo(Integer value) {
            addCriterion("refunded_amount =", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountNotEqualTo(Integer value) {
            addCriterion("refunded_amount <>", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountGreaterThan(Integer value) {
            addCriterion("refunded_amount >", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountGreaterThanOrEqualTo(Integer value) {
            addCriterion("refunded_amount >=", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountLessThan(Integer value) {
            addCriterion("refunded_amount <", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountLessThanOrEqualTo(Integer value) {
            addCriterion("refunded_amount <=", value, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountIn(List<Integer> values) {
            addCriterion("refunded_amount in", values, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountNotIn(List<Integer> values) {
            addCriterion("refunded_amount not in", values, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountBetween(Integer value1, Integer value2) {
            addCriterion("refunded_amount between", value1, value2, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andRefundedAmountNotBetween(Integer value1, Integer value2) {
            addCriterion("refunded_amount not between", value1, value2, "refundedAmount");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridIsNull() {
            addCriterion("buyerCustomerId is null");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridIsNotNull() {
            addCriterion("buyerCustomerId is not null");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridEqualTo(Integer value) {
            addCriterion("buyerCustomerId =", value, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridNotEqualTo(Integer value) {
            addCriterion("buyerCustomerId <>", value, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridGreaterThan(Integer value) {
            addCriterion("buyerCustomerId >", value, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("buyerCustomerId >=", value, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridLessThan(Integer value) {
            addCriterion("buyerCustomerId <", value, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridLessThanOrEqualTo(Integer value) {
            addCriterion("buyerCustomerId <=", value, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridIn(List<Integer> values) {
            addCriterion("buyerCustomerId in", values, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridNotIn(List<Integer> values) {
            addCriterion("buyerCustomerId not in", values, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridBetween(Integer value1, Integer value2) {
            addCriterion("buyerCustomerId between", value1, value2, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomeridNotBetween(Integer value1, Integer value2) {
            addCriterion("buyerCustomerId not between", value1, value2, "buyercustomerid");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameIsNull() {
            addCriterion("buyerCustomerName is null");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameIsNotNull() {
            addCriterion("buyerCustomerName is not null");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameEqualTo(String value) {
            addCriterion("buyerCustomerName =", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameNotEqualTo(String value) {
            addCriterion("buyerCustomerName <>", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameGreaterThan(String value) {
            addCriterion("buyerCustomerName >", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameGreaterThanOrEqualTo(String value) {
            addCriterion("buyerCustomerName >=", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameLessThan(String value) {
            addCriterion("buyerCustomerName <", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameLessThanOrEqualTo(String value) {
            addCriterion("buyerCustomerName <=", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameLike(String value) {
            addCriterion("buyerCustomerName like", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameNotLike(String value) {
            addCriterion("buyerCustomerName not like", value, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameIn(List<String> values) {
            addCriterion("buyerCustomerName in", values, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameNotIn(List<String> values) {
            addCriterion("buyerCustomerName not in", values, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameBetween(String value1, String value2) {
            addCriterion("buyerCustomerName between", value1, value2, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andBuyercustomernameNotBetween(String value1, String value2) {
            addCriterion("buyerCustomerName not between", value1, value2, "buyercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridIsNull() {
            addCriterion("sellerCustomerId is null");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridIsNotNull() {
            addCriterion("sellerCustomerId is not null");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridEqualTo(Integer value) {
            addCriterion("sellerCustomerId =", value, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridNotEqualTo(Integer value) {
            addCriterion("sellerCustomerId <>", value, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridGreaterThan(Integer value) {
            addCriterion("sellerCustomerId >", value, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("sellerCustomerId >=", value, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridLessThan(Integer value) {
            addCriterion("sellerCustomerId <", value, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridLessThanOrEqualTo(Integer value) {
            addCriterion("sellerCustomerId <=", value, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridIn(List<Integer> values) {
            addCriterion("sellerCustomerId in", values, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridNotIn(List<Integer> values) {
            addCriterion("sellerCustomerId not in", values, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridBetween(Integer value1, Integer value2) {
            addCriterion("sellerCustomerId between", value1, value2, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomeridNotBetween(Integer value1, Integer value2) {
            addCriterion("sellerCustomerId not between", value1, value2, "sellercustomerid");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameIsNull() {
            addCriterion("sellerCustomerName is null");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameIsNotNull() {
            addCriterion("sellerCustomerName is not null");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameEqualTo(String value) {
            addCriterion("sellerCustomerName =", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameNotEqualTo(String value) {
            addCriterion("sellerCustomerName <>", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameGreaterThan(String value) {
            addCriterion("sellerCustomerName >", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameGreaterThanOrEqualTo(String value) {
            addCriterion("sellerCustomerName >=", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameLessThan(String value) {
            addCriterion("sellerCustomerName <", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameLessThanOrEqualTo(String value) {
            addCriterion("sellerCustomerName <=", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameLike(String value) {
            addCriterion("sellerCustomerName like", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameNotLike(String value) {
            addCriterion("sellerCustomerName not like", value, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameIn(List<String> values) {
            addCriterion("sellerCustomerName in", values, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameNotIn(List<String> values) {
            addCriterion("sellerCustomerName not in", values, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameBetween(String value1, String value2) {
            addCriterion("sellerCustomerName between", value1, value2, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andSellercustomernameNotBetween(String value1, String value2) {
            addCriterion("sellerCustomerName not between", value1, value2, "sellercustomername");
            return (Criteria) this;
        }

        public Criteria andOrderstateIsNull() {
            addCriterion("orderState is null");
            return (Criteria) this;
        }

        public Criteria andOrderstateIsNotNull() {
            addCriterion("orderState is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstateEqualTo(Integer value) {
            addCriterion("orderState =", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotEqualTo(Integer value) {
            addCriterion("orderState <>", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateGreaterThan(Integer value) {
            addCriterion("orderState >", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderState >=", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateLessThan(Integer value) {
            addCriterion("orderState <", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateLessThanOrEqualTo(Integer value) {
            addCriterion("orderState <=", value, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateIn(List<Integer> values) {
            addCriterion("orderState in", values, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotIn(List<Integer> values) {
            addCriterion("orderState not in", values, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateBetween(Integer value1, Integer value2) {
            addCriterion("orderState between", value1, value2, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrderstateNotBetween(Integer value1, Integer value2) {
            addCriterion("orderState not between", value1, value2, "orderstate");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNull() {
            addCriterion("orderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("orderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(String value) {
            addCriterion("orderTime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(String value) {
            addCriterion("orderTime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(String value) {
            addCriterion("orderTime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(String value) {
            addCriterion("orderTime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(String value) {
            addCriterion("orderTime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(String value) {
            addCriterion("orderTime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLike(String value) {
            addCriterion("orderTime like", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotLike(String value) {
            addCriterion("orderTime not like", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<String> values) {
            addCriterion("orderTime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<String> values) {
            addCriterion("orderTime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(String value1, String value2) {
            addCriterion("orderTime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(String value1, String value2) {
            addCriterion("orderTime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountIsNull() {
            addCriterion("rechargeAccount is null");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountIsNotNull() {
            addCriterion("rechargeAccount is not null");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountEqualTo(String value) {
            addCriterion("rechargeAccount =", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountNotEqualTo(String value) {
            addCriterion("rechargeAccount <>", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountGreaterThan(String value) {
            addCriterion("rechargeAccount >", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountGreaterThanOrEqualTo(String value) {
            addCriterion("rechargeAccount >=", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountLessThan(String value) {
            addCriterion("rechargeAccount <", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountLessThanOrEqualTo(String value) {
            addCriterion("rechargeAccount <=", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountLike(String value) {
            addCriterion("rechargeAccount like", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountNotLike(String value) {
            addCriterion("rechargeAccount not like", value, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountIn(List<String> values) {
            addCriterion("rechargeAccount in", values, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountNotIn(List<String> values) {
            addCriterion("rechargeAccount not in", values, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountBetween(String value1, String value2) {
            addCriterion("rechargeAccount between", value1, value2, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andRechargeaccountNotBetween(String value1, String value2) {
            addCriterion("rechargeAccount not between", value1, value2, "rechargeaccount");
            return (Criteria) this;
        }

        public Criteria andProgressinitIsNull() {
            addCriterion("progressInit is null");
            return (Criteria) this;
        }

        public Criteria andProgressinitIsNotNull() {
            addCriterion("progressInit is not null");
            return (Criteria) this;
        }

        public Criteria andProgressinitEqualTo(Integer value) {
            addCriterion("progressInit =", value, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitNotEqualTo(Integer value) {
            addCriterion("progressInit <>", value, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitGreaterThan(Integer value) {
            addCriterion("progressInit >", value, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitGreaterThanOrEqualTo(Integer value) {
            addCriterion("progressInit >=", value, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitLessThan(Integer value) {
            addCriterion("progressInit <", value, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitLessThanOrEqualTo(Integer value) {
            addCriterion("progressInit <=", value, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitIn(List<Integer> values) {
            addCriterion("progressInit in", values, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitNotIn(List<Integer> values) {
            addCriterion("progressInit not in", values, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitBetween(Integer value1, Integer value2) {
            addCriterion("progressInit between", value1, value2, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressinitNotBetween(Integer value1, Integer value2) {
            addCriterion("progressInit not between", value1, value2, "progressinit");
            return (Criteria) this;
        }

        public Criteria andProgressnowIsNull() {
            addCriterion("progressNow is null");
            return (Criteria) this;
        }

        public Criteria andProgressnowIsNotNull() {
            addCriterion("progressNow is not null");
            return (Criteria) this;
        }

        public Criteria andProgressnowEqualTo(Integer value) {
            addCriterion("progressNow =", value, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowNotEqualTo(Integer value) {
            addCriterion("progressNow <>", value, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowGreaterThan(Integer value) {
            addCriterion("progressNow >", value, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowGreaterThanOrEqualTo(Integer value) {
            addCriterion("progressNow >=", value, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowLessThan(Integer value) {
            addCriterion("progressNow <", value, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowLessThanOrEqualTo(Integer value) {
            addCriterion("progressNow <=", value, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowIn(List<Integer> values) {
            addCriterion("progressNow in", values, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowNotIn(List<Integer> values) {
            addCriterion("progressNow not in", values, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowBetween(Integer value1, Integer value2) {
            addCriterion("progressNow between", value1, value2, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgressnowNotBetween(Integer value1, Integer value2) {
            addCriterion("progressNow not between", value1, value2, "progressnow");
            return (Criteria) this;
        }

        public Criteria andProgresstargetIsNull() {
            addCriterion("progressTarget is null");
            return (Criteria) this;
        }

        public Criteria andProgresstargetIsNotNull() {
            addCriterion("progressTarget is not null");
            return (Criteria) this;
        }

        public Criteria andProgresstargetEqualTo(Integer value) {
            addCriterion("progressTarget =", value, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetNotEqualTo(Integer value) {
            addCriterion("progressTarget <>", value, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetGreaterThan(Integer value) {
            addCriterion("progressTarget >", value, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetGreaterThanOrEqualTo(Integer value) {
            addCriterion("progressTarget >=", value, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetLessThan(Integer value) {
            addCriterion("progressTarget <", value, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetLessThanOrEqualTo(Integer value) {
            addCriterion("progressTarget <=", value, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetIn(List<Integer> values) {
            addCriterion("progressTarget in", values, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetNotIn(List<Integer> values) {
            addCriterion("progressTarget not in", values, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetBetween(Integer value1, Integer value2) {
            addCriterion("progressTarget between", value1, value2, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andProgresstargetNotBetween(Integer value1, Integer value2) {
            addCriterion("progressTarget not between", value1, value2, "progresstarget");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoIsNull() {
            addCriterion("rechargeInfo is null");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoIsNotNull() {
            addCriterion("rechargeInfo is not null");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoEqualTo(String value) {
            addCriterion("rechargeInfo =", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoNotEqualTo(String value) {
            addCriterion("rechargeInfo <>", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoGreaterThan(String value) {
            addCriterion("rechargeInfo >", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoGreaterThanOrEqualTo(String value) {
            addCriterion("rechargeInfo >=", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoLessThan(String value) {
            addCriterion("rechargeInfo <", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoLessThanOrEqualTo(String value) {
            addCriterion("rechargeInfo <=", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoLike(String value) {
            addCriterion("rechargeInfo like", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoNotLike(String value) {
            addCriterion("rechargeInfo not like", value, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoIn(List<String> values) {
            addCriterion("rechargeInfo in", values, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoNotIn(List<String> values) {
            addCriterion("rechargeInfo not in", values, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoBetween(String value1, String value2) {
            addCriterion("rechargeInfo between", value1, value2, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeinfoNotBetween(String value1, String value2) {
            addCriterion("rechargeInfo not between", value1, value2, "rechargeinfo");
            return (Criteria) this;
        }

        public Criteria andRechargeurlIsNull() {
            addCriterion("rechargeUrl is null");
            return (Criteria) this;
        }

        public Criteria andRechargeurlIsNotNull() {
            addCriterion("rechargeUrl is not null");
            return (Criteria) this;
        }

        public Criteria andRechargeurlEqualTo(String value) {
            addCriterion("rechargeUrl =", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlNotEqualTo(String value) {
            addCriterion("rechargeUrl <>", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlGreaterThan(String value) {
            addCriterion("rechargeUrl >", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlGreaterThanOrEqualTo(String value) {
            addCriterion("rechargeUrl >=", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlLessThan(String value) {
            addCriterion("rechargeUrl <", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlLessThanOrEqualTo(String value) {
            addCriterion("rechargeUrl <=", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlLike(String value) {
            addCriterion("rechargeUrl like", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlNotLike(String value) {
            addCriterion("rechargeUrl not like", value, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlIn(List<String> values) {
            addCriterion("rechargeUrl in", values, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlNotIn(List<String> values) {
            addCriterion("rechargeUrl not in", values, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlBetween(String value1, String value2) {
            addCriterion("rechargeUrl between", value1, value2, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andRechargeurlNotBetween(String value1, String value2) {
            addCriterion("rechargeUrl not between", value1, value2, "rechargeurl");
            return (Criteria) this;
        }

        public Criteria andCardspasswordIsNull() {
            addCriterion("cardsPassword is null");
            return (Criteria) this;
        }

        public Criteria andCardspasswordIsNotNull() {
            addCriterion("cardsPassword is not null");
            return (Criteria) this;
        }

        public Criteria andCardspasswordEqualTo(String value) {
            addCriterion("cardsPassword =", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordNotEqualTo(String value) {
            addCriterion("cardsPassword <>", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordGreaterThan(String value) {
            addCriterion("cardsPassword >", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordGreaterThanOrEqualTo(String value) {
            addCriterion("cardsPassword >=", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordLessThan(String value) {
            addCriterion("cardsPassword <", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordLessThanOrEqualTo(String value) {
            addCriterion("cardsPassword <=", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordLike(String value) {
            addCriterion("cardsPassword like", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordNotLike(String value) {
            addCriterion("cardsPassword not like", value, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordIn(List<String> values) {
            addCriterion("cardsPassword in", values, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordNotIn(List<String> values) {
            addCriterion("cardsPassword not in", values, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordBetween(String value1, String value2) {
            addCriterion("cardsPassword between", value1, value2, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andCardspasswordNotBetween(String value1, String value2) {
            addCriterion("cardsPassword not between", value1, value2, "cardspassword");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateIsNull() {
            addCriterion("superior_commissions_rate is null");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateIsNotNull() {
            addCriterion("superior_commissions_rate is not null");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateEqualTo(String value) {
            addCriterion("superior_commissions_rate =", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateNotEqualTo(String value) {
            addCriterion("superior_commissions_rate <>", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateGreaterThan(String value) {
            addCriterion("superior_commissions_rate >", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateGreaterThanOrEqualTo(String value) {
            addCriterion("superior_commissions_rate >=", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateLessThan(String value) {
            addCriterion("superior_commissions_rate <", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateLessThanOrEqualTo(String value) {
            addCriterion("superior_commissions_rate <=", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateLike(String value) {
            addCriterion("superior_commissions_rate like", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateNotLike(String value) {
            addCriterion("superior_commissions_rate not like", value, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateIn(List<String> values) {
            addCriterion("superior_commissions_rate in", values, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateNotIn(List<String> values) {
            addCriterion("superior_commissions_rate not in", values, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateBetween(String value1, String value2) {
            addCriterion("superior_commissions_rate between", value1, value2, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andSuperiorCommissionsRateNotBetween(String value1, String value2) {
            addCriterion("superior_commissions_rate not between", value1, value2, "superiorCommissionsRate");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(String value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(String value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(String value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(String value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(String value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(String value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLike(String value) {
            addCriterion("createtime like", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotLike(String value) {
            addCriterion("createtime not like", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<String> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<String> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(String value1, String value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(String value1, String value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updatetime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updatetime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(String value) {
            addCriterion("updatetime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(String value) {
            addCriterion("updatetime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(String value) {
            addCriterion("updatetime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(String value) {
            addCriterion("updatetime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(String value) {
            addCriterion("updatetime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(String value) {
            addCriterion("updatetime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLike(String value) {
            addCriterion("updatetime like", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotLike(String value) {
            addCriterion("updatetime not like", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<String> values) {
            addCriterion("updatetime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<String> values) {
            addCriterion("updatetime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(String value1, String value2) {
            addCriterion("updatetime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(String value1, String value2) {
            addCriterion("updatetime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andWeighIsNull() {
            addCriterion("weigh is null");
            return (Criteria) this;
        }

        public Criteria andWeighIsNotNull() {
            addCriterion("weigh is not null");
            return (Criteria) this;
        }

        public Criteria andWeighEqualTo(Integer value) {
            addCriterion("weigh =", value, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighNotEqualTo(Integer value) {
            addCriterion("weigh <>", value, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighGreaterThan(Integer value) {
            addCriterion("weigh >", value, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighGreaterThanOrEqualTo(Integer value) {
            addCriterion("weigh >=", value, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighLessThan(Integer value) {
            addCriterion("weigh <", value, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighLessThanOrEqualTo(Integer value) {
            addCriterion("weigh <=", value, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighIn(List<Integer> values) {
            addCriterion("weigh in", values, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighNotIn(List<Integer> values) {
            addCriterion("weigh not in", values, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighBetween(Integer value1, Integer value2) {
            addCriterion("weigh between", value1, value2, "weigh");
            return (Criteria) this;
        }

        public Criteria andWeighNotBetween(Integer value1, Integer value2) {
            addCriterion("weigh not between", value1, value2, "weigh");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}